📊 Visual Query
Allows non-technical users to build database queries through an intuitive drag-and-drop graphical interface.
- Eliminates the need for manual SQL coding by enabling users to visually select tables, fields, filters, and joins.
- Supports complex query constructs including multiple table joins, aggregation, sorting, and grouping.
- Provides real-time preview of query results to validate output before execution.
- Enables saving and reusing frequently used queries for consistency and efficiency.
- Supports integration with various relational databases configured in the system.
- Empowers business analysts and data consumers to access data insights without reliance on developers.
- Facilitates rapid prototyping and iterative data exploration to accelerate decision-making.
Use case:
- Create custom reports and dashboards without technical expertise.
- Empower users to extract data for analysis, reducing backlog on IT teams.
- Quickly adapt queries to changing business requirements via a user-friendly UI.
Key Features:
- Drag-and-drop interface for building SELECT, WHERE, JOIN, GROUP BY clauses.
- Validation and syntax checks to prevent query errors.
- Export and share query results in multiple formats.
- Seamless integration into Pageflows automation for further processing or notifications.
- User-Friendly Interface: Designed to cater to users without SQL knowledge, enabling them to interact with databases through a visual builder.
- Multi-Database Support: Works with multiple types of databases (e.g., SQL Server, MySQL, PostgreSQL), abstracting complexities of different SQL dialects.
- Dynamic Filtering: Allows adding dynamic filters and parameters that can be modified at runtime or driven by user inputs within Pageflows.
- Conditional Logic: Supports creating conditional query components to tailor results based on various criteria or Pageflows variables.
- Performance Optimization: Provides hints and warnings for potentially expensive operations like full table scans or Cartesian joins, helping users build efficient queries.
- Security and Access Control: Respects database security policies and user permissions, preventing unauthorized data access through query builder constraints.
- Integration with Pageflows: Directly embed visual queries within Pageflows to fetch, manipulate, and route data seamlessly as part of automation pipelines.
- Export Options: Ability to export queries and results in formats like CSV, Excel, JSON, or connect directly to visualization tools.
- Audit and Versioning: Tracks changes made to queries, enabling rollback and audit trails for compliance and governance.
Advanced Use Cases:
- Build customized data views for dashboards and reporting modules.
- Empower citizen developers to create data extracts for marketing, sales, and operations teams.
- Combine visual query outputs with other data transformation actions in Pageflows for end-to-end automation.
- Use query results as triggers or conditions in complex decision-making Pageflows.
Example Use Cases​
-
Business Reporting: Marketing teams build sales and customer segmentation reports without waiting for IT.
-
Operational Dashboards: Operations staff create visual queries for real-time monitoring of inventory, shipments, or production KPIs.
-
Ad-Hoc Data Analysis: Data analysts explore datasets interactively to uncover trends or validate hypotheses.
-
Pageflows Automation: Visual query outputs feed directly into automation Pageflows for decision-making, notifications, or data transformations.
How It Works in Pageflows​
-
Add Visual Query Action: Drag the Visual Query action block into your Pageflows.
-
Design Query: Use the interface to select tables, fields, and conditions.
-
Configure Parameters: Bind parameters to Pageflows variables or external inputs.
-
Test and Preview: Validate the query logic with live data previews.
-
Use Output: The resulting dataset can trigger other actions or be passed along the Pageflows.
By leveraging Visual Query, your organization can unlock the power of data to drive smarter decisions, faster delivery, and greater operational efficiency — all without deep SQL expertise.